Release 10.1A: OpenEdge Development:
Progress 4GL Reference

INDEX-INFORMATION( ) method

Returns index information in a comma-separated list for the i^th index in the buffer’s table.

The returned comma-separated list consists of the following in the specified order:

The index name.
Three integers of value 0 (FALSE) or 1 (TRUE) depending on whether the index is unique, primary or a word index.
The names of the index fields, each followed by a 0 (ascending) or 1 (descending).
Return type: CHARACTER
Applies to: Buffer object handle

Syntax

INDEX-INFORMATION(i)

i

The relative number of the buffer table’s index for which you want information.

Note

When the index argument, i, is beyond the number of indices in the table or is otherwise invalid, the Unknown value (?) is returned.

Example

The following code fragment requests information about the third index in the customer table:

buffCustHdl = BUFFER customer:HANDLE. IndexVar = buffCustHdl:INDEX-INFORMATION(3).

The returned string would look like: “cust-num,1,1,0,cust-num,0" which means that the third index in the customer table is called “cust-num”. It is unique and primary, and is not a word index and it consists of one ascending component, cust-num.